package com.hrd.mybatis.bean.auto;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TMLPlanBillExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected int limitStart = -1;

    protected int limitEnd = -1;

    public TMLPlanBillExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void setLimitStart(int limitStart) {
        this.limitStart=limitStart;
    }

    public int getLimitStart() {
        return limitStart;
    }

    public void setLimitEnd(int limitEnd) {
        this.limitEnd=limitEnd;
    }

    public int getLimitEnd() {
        return limitEnd;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andFidIsNull() {
            addCriterion("fID is null");
            return (Criteria) this;
        }

        public Criteria andFidIsNotNull() {
            addCriterion("fID is not null");
            return (Criteria) this;
        }

        public Criteria andFidEqualTo(Integer value) {
            addCriterion("fID =", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotEqualTo(Integer value) {
            addCriterion("fID <>", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThan(Integer value) {
            addCriterion("fID >", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fID >=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThan(Integer value) {
            addCriterion("fID <", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidLessThanOrEqualTo(Integer value) {
            addCriterion("fID <=", value, "fid");
            return (Criteria) this;
        }

        public Criteria andFidIn(List<Integer> values) {
            addCriterion("fID in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotIn(List<Integer> values) {
            addCriterion("fID not in", values, "fid");
            return (Criteria) this;
        }

        public Criteria andFidBetween(Integer value1, Integer value2) {
            addCriterion("fID between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFidNotBetween(Integer value1, Integer value2) {
            addCriterion("fID not between", value1, value2, "fid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNull() {
            addCriterion("fItemClassID is null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIsNotNull() {
            addCriterion("fItemClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFitemclassidEqualTo(Integer value) {
            addCriterion("fItemClassID =", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotEqualTo(Integer value) {
            addCriterion("fItemClassID <>", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThan(Integer value) {
            addCriterion("fItemClassID >", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID >=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThan(Integer value) {
            addCriterion("fItemClassID <", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fItemClassID <=", value, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidIn(List<Integer> values) {
            addCriterion("fItemClassID in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotIn(List<Integer> values) {
            addCriterion("fItemClassID not in", values, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFitemclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fItemClassID not between", value1, value2, "fitemclassid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNull() {
            addCriterion("fCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIsNotNull() {
            addCriterion("fCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFcompanyidEqualTo(Integer value) {
            addCriterion("fCompanyID =", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotEqualTo(Integer value) {
            addCriterion("fCompanyID <>", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThan(Integer value) {
            addCriterion("fCompanyID >", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID >=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThan(Integer value) {
            addCriterion("fCompanyID <", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fCompanyID <=", value, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidIn(List<Integer> values) {
            addCriterion("fCompanyID in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotIn(List<Integer> values) {
            addCriterion("fCompanyID not in", values, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFcompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCompanyID not between", value1, value2, "fcompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNull() {
            addCriterion("fSCompanyID is null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIsNotNull() {
            addCriterion("fSCompanyID is not null");
            return (Criteria) this;
        }

        public Criteria andFscompanyidEqualTo(Integer value) {
            addCriterion("fSCompanyID =", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotEqualTo(Integer value) {
            addCriterion("fSCompanyID <>", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThan(Integer value) {
            addCriterion("fSCompanyID >", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID >=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThan(Integer value) {
            addCriterion("fSCompanyID <", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidLessThanOrEqualTo(Integer value) {
            addCriterion("fSCompanyID <=", value, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidIn(List<Integer> values) {
            addCriterion("fSCompanyID in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotIn(List<Integer> values) {
            addCriterion("fSCompanyID not in", values, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFscompanyidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSCompanyID not between", value1, value2, "fscompanyid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIsNull() {
            addCriterion("fArchivesID is null");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIsNotNull() {
            addCriterion("fArchivesID is not null");
            return (Criteria) this;
        }

        public Criteria andFarchivesidEqualTo(Integer value) {
            addCriterion("fArchivesID =", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotEqualTo(Integer value) {
            addCriterion("fArchivesID <>", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidGreaterThan(Integer value) {
            addCriterion("fArchivesID >", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fArchivesID >=", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidLessThan(Integer value) {
            addCriterion("fArchivesID <", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidLessThanOrEqualTo(Integer value) {
            addCriterion("fArchivesID <=", value, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidIn(List<Integer> values) {
            addCriterion("fArchivesID in", values, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotIn(List<Integer> values) {
            addCriterion("fArchivesID not in", values, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidBetween(Integer value1, Integer value2) {
            addCriterion("fArchivesID between", value1, value2, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFarchivesidNotBetween(Integer value1, Integer value2) {
            addCriterion("fArchivesID not between", value1, value2, "farchivesid");
            return (Criteria) this;
        }

        public Criteria andFnoIsNull() {
            addCriterion("fNO is null");
            return (Criteria) this;
        }

        public Criteria andFnoIsNotNull() {
            addCriterion("fNO is not null");
            return (Criteria) this;
        }

        public Criteria andFnoEqualTo(String value) {
            addCriterion("fNO =", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotEqualTo(String value) {
            addCriterion("fNO <>", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThan(String value) {
            addCriterion("fNO >", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoGreaterThanOrEqualTo(String value) {
            addCriterion("fNO >=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThan(String value) {
            addCriterion("fNO <", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLessThanOrEqualTo(String value) {
            addCriterion("fNO <=", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoLike(String value) {
            addCriterion("fNO like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotLike(String value) {
            addCriterion("fNO not like", value, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoIn(List<String> values) {
            addCriterion("fNO in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotIn(List<String> values) {
            addCriterion("fNO not in", values, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoBetween(String value1, String value2) {
            addCriterion("fNO between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFnoNotBetween(String value1, String value2) {
            addCriterion("fNO not between", value1, value2, "fno");
            return (Criteria) this;
        }

        public Criteria andFdateIsNull() {
            addCriterion("fDate is null");
            return (Criteria) this;
        }

        public Criteria andFdateIsNotNull() {
            addCriterion("fDate is not null");
            return (Criteria) this;
        }

        public Criteria andFdateEqualTo(Date value) {
            addCriterion("fDate =", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotEqualTo(Date value) {
            addCriterion("fDate <>", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateGreaterThan(Date value) {
            addCriterion("fDate >", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fDate >=", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateLessThan(Date value) {
            addCriterion("fDate <", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateLessThanOrEqualTo(Date value) {
            addCriterion("fDate <=", value, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateIn(List<Date> values) {
            addCriterion("fDate in", values, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotIn(List<Date> values) {
            addCriterion("fDate not in", values, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateBetween(Date value1, Date value2) {
            addCriterion("fDate between", value1, value2, "fdate");
            return (Criteria) this;
        }

        public Criteria andFdateNotBetween(Date value1, Date value2) {
            addCriterion("fDate not between", value1, value2, "fdate");
            return (Criteria) this;
        }

        public Criteria andFplandateIsNull() {
            addCriterion("fPlanDate is null");
            return (Criteria) this;
        }

        public Criteria andFplandateIsNotNull() {
            addCriterion("fPlanDate is not null");
            return (Criteria) this;
        }

        public Criteria andFplandateEqualTo(Date value) {
            addCriterion("fPlanDate =", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotEqualTo(Date value) {
            addCriterion("fPlanDate <>", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateGreaterThan(Date value) {
            addCriterion("fPlanDate >", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateGreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanDate >=", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateLessThan(Date value) {
            addCriterion("fPlanDate <", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateLessThanOrEqualTo(Date value) {
            addCriterion("fPlanDate <=", value, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateIn(List<Date> values) {
            addCriterion("fPlanDate in", values, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotIn(List<Date> values) {
            addCriterion("fPlanDate not in", values, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateBetween(Date value1, Date value2) {
            addCriterion("fPlanDate between", value1, value2, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFplandateNotBetween(Date value1, Date value2) {
            addCriterion("fPlanDate not between", value1, value2, "fplandate");
            return (Criteria) this;
        }

        public Criteria andFactualdateIsNull() {
            addCriterion("fActualDate is null");
            return (Criteria) this;
        }

        public Criteria andFactualdateIsNotNull() {
            addCriterion("fActualDate is not null");
            return (Criteria) this;
        }

        public Criteria andFactualdateEqualTo(Date value) {
            addCriterion("fActualDate =", value, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateNotEqualTo(Date value) {
            addCriterion("fActualDate <>", value, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateGreaterThan(Date value) {
            addCriterion("fActualDate >", value, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fActualDate >=", value, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateLessThan(Date value) {
            addCriterion("fActualDate <", value, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateLessThanOrEqualTo(Date value) {
            addCriterion("fActualDate <=", value, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateIn(List<Date> values) {
            addCriterion("fActualDate in", values, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateNotIn(List<Date> values) {
            addCriterion("fActualDate not in", values, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateBetween(Date value1, Date value2) {
            addCriterion("fActualDate between", value1, value2, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFactualdateNotBetween(Date value1, Date value2) {
            addCriterion("fActualDate not between", value1, value2, "factualdate");
            return (Criteria) this;
        }

        public Criteria andFtotalsumIsNull() {
            addCriterion("fTotalSum is null");
            return (Criteria) this;
        }

        public Criteria andFtotalsumIsNotNull() {
            addCriterion("fTotalSum is not null");
            return (Criteria) this;
        }

        public Criteria andFtotalsumEqualTo(BigDecimal value) {
            addCriterion("fTotalSum =", value, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumNotEqualTo(BigDecimal value) {
            addCriterion("fTotalSum <>", value, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumGreaterThan(BigDecimal value) {
            addCriterion("fTotalSum >", value, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotalSum >=", value, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumLessThan(BigDecimal value) {
            addCriterion("fTotalSum <", value, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fTotalSum <=", value, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumIn(List<BigDecimal> values) {
            addCriterion("fTotalSum in", values, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumNotIn(List<BigDecimal> values) {
            addCriterion("fTotalSum not in", values, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotalSum between", value1, value2, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFtotalsumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fTotalSum not between", value1, value2, "ftotalsum");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidIsNull() {
            addCriterion("fPayModeID is null");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidIsNotNull() {
            addCriterion("fPayModeID is not null");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidEqualTo(Integer value) {
            addCriterion("fPayModeID =", value, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidNotEqualTo(Integer value) {
            addCriterion("fPayModeID <>", value, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidGreaterThan(Integer value) {
            addCriterion("fPayModeID >", value, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPayModeID >=", value, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidLessThan(Integer value) {
            addCriterion("fPayModeID <", value, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidLessThanOrEqualTo(Integer value) {
            addCriterion("fPayModeID <=", value, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidIn(List<Integer> values) {
            addCriterion("fPayModeID in", values, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidNotIn(List<Integer> values) {
            addCriterion("fPayModeID not in", values, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidBetween(Integer value1, Integer value2) {
            addCriterion("fPayModeID between", value1, value2, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFpaymodeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fPayModeID not between", value1, value2, "fpaymodeid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNull() {
            addCriterion("fRunStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIsNotNull() {
            addCriterion("fRunStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidEqualTo(Integer value) {
            addCriterion("fRunStatusID =", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotEqualTo(Integer value) {
            addCriterion("fRunStatusID <>", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThan(Integer value) {
            addCriterion("fRunStatusID >", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID >=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThan(Integer value) {
            addCriterion("fRunStatusID <", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fRunStatusID <=", value, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidIn(List<Integer> values) {
            addCriterion("fRunStatusID in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotIn(List<Integer> values) {
            addCriterion("fRunStatusID not in", values, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFrunstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRunStatusID not between", value1, value2, "frunstatusid");
            return (Criteria) this;
        }

        public Criteria andFsourceidIsNull() {
            addCriterion("fSourceID is null");
            return (Criteria) this;
        }

        public Criteria andFsourceidIsNotNull() {
            addCriterion("fSourceID is not null");
            return (Criteria) this;
        }

        public Criteria andFsourceidEqualTo(Integer value) {
            addCriterion("fSourceID =", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidNotEqualTo(Integer value) {
            addCriterion("fSourceID <>", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidGreaterThan(Integer value) {
            addCriterion("fSourceID >", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSourceID >=", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidLessThan(Integer value) {
            addCriterion("fSourceID <", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidLessThanOrEqualTo(Integer value) {
            addCriterion("fSourceID <=", value, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidIn(List<Integer> values) {
            addCriterion("fSourceID in", values, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidNotIn(List<Integer> values) {
            addCriterion("fSourceID not in", values, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidBetween(Integer value1, Integer value2) {
            addCriterion("fSourceID between", value1, value2, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFsourceidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSourceID not between", value1, value2, "fsourceid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNull() {
            addCriterion("fStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFstatusidIsNotNull() {
            addCriterion("fStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFstatusidEqualTo(Integer value) {
            addCriterion("fStatusID =", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotEqualTo(Integer value) {
            addCriterion("fStatusID <>", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThan(Integer value) {
            addCriterion("fStatusID >", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fStatusID >=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThan(Integer value) {
            addCriterion("fStatusID <", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fStatusID <=", value, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidIn(List<Integer> values) {
            addCriterion("fStatusID in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotIn(List<Integer> values) {
            addCriterion("fStatusID not in", values, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fStatusID between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fStatusID not between", value1, value2, "fstatusid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNull() {
            addCriterion("fOperUserID is null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIsNotNull() {
            addCriterion("fOperUserID is not null");
            return (Criteria) this;
        }

        public Criteria andFoperuseridEqualTo(Integer value) {
            addCriterion("fOperUserID =", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotEqualTo(Integer value) {
            addCriterion("fOperUserID <>", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThan(Integer value) {
            addCriterion("fOperUserID >", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID >=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThan(Integer value) {
            addCriterion("fOperUserID <", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridLessThanOrEqualTo(Integer value) {
            addCriterion("fOperUserID <=", value, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridIn(List<Integer> values) {
            addCriterion("fOperUserID in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotIn(List<Integer> values) {
            addCriterion("fOperUserID not in", values, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperuseridNotBetween(Integer value1, Integer value2) {
            addCriterion("fOperUserID not between", value1, value2, "foperuserid");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNull() {
            addCriterion("fOperDate is null");
            return (Criteria) this;
        }

        public Criteria andFoperdateIsNotNull() {
            addCriterion("fOperDate is not null");
            return (Criteria) this;
        }

        public Criteria andFoperdateEqualTo(Date value) {
            addCriterion("fOperDate =", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotEqualTo(Date value) {
            addCriterion("fOperDate <>", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThan(Date value) {
            addCriterion("fOperDate >", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fOperDate >=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThan(Date value) {
            addCriterion("fOperDate <", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateLessThanOrEqualTo(Date value) {
            addCriterion("fOperDate <=", value, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateIn(List<Date> values) {
            addCriterion("fOperDate in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotIn(List<Date> values) {
            addCriterion("fOperDate not in", values, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateBetween(Date value1, Date value2) {
            addCriterion("fOperDate between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFoperdateNotBetween(Date value1, Date value2) {
            addCriterion("fOperDate not between", value1, value2, "foperdate");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNull() {
            addCriterion("fMemo is null");
            return (Criteria) this;
        }

        public Criteria andFmemoIsNotNull() {
            addCriterion("fMemo is not null");
            return (Criteria) this;
        }

        public Criteria andFmemoEqualTo(String value) {
            addCriterion("fMemo =", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotEqualTo(String value) {
            addCriterion("fMemo <>", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThan(String value) {
            addCriterion("fMemo >", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoGreaterThanOrEqualTo(String value) {
            addCriterion("fMemo >=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThan(String value) {
            addCriterion("fMemo <", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLessThanOrEqualTo(String value) {
            addCriterion("fMemo <=", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoLike(String value) {
            addCriterion("fMemo like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotLike(String value) {
            addCriterion("fMemo not like", value, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoIn(List<String> values) {
            addCriterion("fMemo in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotIn(List<String> values) {
            addCriterion("fMemo not in", values, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoBetween(String value1, String value2) {
            addCriterion("fMemo between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFmemoNotBetween(String value1, String value2) {
            addCriterion("fMemo not between", value1, value2, "fmemo");
            return (Criteria) this;
        }

        public Criteria andFcostitemidIsNull() {
            addCriterion("fCostItemID is null");
            return (Criteria) this;
        }

        public Criteria andFcostitemidIsNotNull() {
            addCriterion("fCostItemID is not null");
            return (Criteria) this;
        }

        public Criteria andFcostitemidEqualTo(Integer value) {
            addCriterion("fCostItemID =", value, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidNotEqualTo(Integer value) {
            addCriterion("fCostItemID <>", value, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidGreaterThan(Integer value) {
            addCriterion("fCostItemID >", value, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCostItemID >=", value, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidLessThan(Integer value) {
            addCriterion("fCostItemID <", value, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidLessThanOrEqualTo(Integer value) {
            addCriterion("fCostItemID <=", value, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidIn(List<Integer> values) {
            addCriterion("fCostItemID in", values, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidNotIn(List<Integer> values) {
            addCriterion("fCostItemID not in", values, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidBetween(Integer value1, Integer value2) {
            addCriterion("fCostItemID between", value1, value2, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFcostitemidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCostItemID not between", value1, value2, "fcostitemid");
            return (Criteria) this;
        }

        public Criteria andFstatusIsNull() {
            addCriterion("fStatus is null");
            return (Criteria) this;
        }

        public Criteria andFstatusIsNotNull() {
            addCriterion("fStatus is not null");
            return (Criteria) this;
        }

        private Criteria andFstatusEqualTo_back(Boolean value) {
            addCriterion("fStatus =", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusNotEqualTo_back(Boolean value) {
            addCriterion("fStatus <>", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusGreaterThan_back(Boolean value) {
            addCriterion("fStatus >", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fStatus >=", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusLessThan_back(Boolean value) {
            addCriterion("fStatus <", value, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fStatus <=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusIn(List<Boolean> values) {
            addCriterion("fStatus in", values, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotIn(List<Boolean> values) {
            addCriterion("fStatus not in", values, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fStatus between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        private Criteria andFstatusNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fStatus not between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesIsNull() {
            addCriterion("fCostItemNames is null");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesIsNotNull() {
            addCriterion("fCostItemNames is not null");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesEqualTo(String value) {
            addCriterion("fCostItemNames =", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesNotEqualTo(String value) {
            addCriterion("fCostItemNames <>", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesGreaterThan(String value) {
            addCriterion("fCostItemNames >", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesGreaterThanOrEqualTo(String value) {
            addCriterion("fCostItemNames >=", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesLessThan(String value) {
            addCriterion("fCostItemNames <", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesLessThanOrEqualTo(String value) {
            addCriterion("fCostItemNames <=", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesLike(String value) {
            addCriterion("fCostItemNames like", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesNotLike(String value) {
            addCriterion("fCostItemNames not like", value, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesIn(List<String> values) {
            addCriterion("fCostItemNames in", values, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesNotIn(List<String> values) {
            addCriterion("fCostItemNames not in", values, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesBetween(String value1, String value2) {
            addCriterion("fCostItemNames between", value1, value2, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFcostitemnamesNotBetween(String value1, String value2) {
            addCriterion("fCostItemNames not between", value1, value2, "fcostitemnames");
            return (Criteria) this;
        }

        public Criteria andFsumtotalIsNull() {
            addCriterion("fSumTotal is null");
            return (Criteria) this;
        }

        public Criteria andFsumtotalIsNotNull() {
            addCriterion("fSumTotal is not null");
            return (Criteria) this;
        }

        public Criteria andFsumtotalEqualTo(BigDecimal value) {
            addCriterion("fSumTotal =", value, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalNotEqualTo(BigDecimal value) {
            addCriterion("fSumTotal <>", value, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalGreaterThan(BigDecimal value) {
            addCriterion("fSumTotal >", value, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fSumTotal >=", value, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalLessThan(BigDecimal value) {
            addCriterion("fSumTotal <", value, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fSumTotal <=", value, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalIn(List<BigDecimal> values) {
            addCriterion("fSumTotal in", values, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalNotIn(List<BigDecimal> values) {
            addCriterion("fSumTotal not in", values, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fSumTotal between", value1, value2, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFsumtotalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fSumTotal not between", value1, value2, "fsumtotal");
            return (Criteria) this;
        }

        public Criteria andFditemidIsNull() {
            addCriterion("fDItemID is null");
            return (Criteria) this;
        }

        public Criteria andFditemidIsNotNull() {
            addCriterion("fDItemID is not null");
            return (Criteria) this;
        }

        public Criteria andFditemidEqualTo(Integer value) {
            addCriterion("fDItemID =", value, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidNotEqualTo(Integer value) {
            addCriterion("fDItemID <>", value, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidGreaterThan(Integer value) {
            addCriterion("fDItemID >", value, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fDItemID >=", value, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidLessThan(Integer value) {
            addCriterion("fDItemID <", value, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidLessThanOrEqualTo(Integer value) {
            addCriterion("fDItemID <=", value, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidIn(List<Integer> values) {
            addCriterion("fDItemID in", values, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidNotIn(List<Integer> values) {
            addCriterion("fDItemID not in", values, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidBetween(Integer value1, Integer value2) {
            addCriterion("fDItemID between", value1, value2, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFditemidNotBetween(Integer value1, Integer value2) {
            addCriterion("fDItemID not between", value1, value2, "fditemid");
            return (Criteria) this;
        }

        public Criteria andFbanknameIsNull() {
            addCriterion("fBankName is null");
            return (Criteria) this;
        }

        public Criteria andFbanknameIsNotNull() {
            addCriterion("fBankName is not null");
            return (Criteria) this;
        }

        public Criteria andFbanknameEqualTo(String value) {
            addCriterion("fBankName =", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameNotEqualTo(String value) {
            addCriterion("fBankName <>", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameGreaterThan(String value) {
            addCriterion("fBankName >", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameGreaterThanOrEqualTo(String value) {
            addCriterion("fBankName >=", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameLessThan(String value) {
            addCriterion("fBankName <", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameLessThanOrEqualTo(String value) {
            addCriterion("fBankName <=", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameLike(String value) {
            addCriterion("fBankName like", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameNotLike(String value) {
            addCriterion("fBankName not like", value, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameIn(List<String> values) {
            addCriterion("fBankName in", values, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameNotIn(List<String> values) {
            addCriterion("fBankName not in", values, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameBetween(String value1, String value2) {
            addCriterion("fBankName between", value1, value2, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknameNotBetween(String value1, String value2) {
            addCriterion("fBankName not between", value1, value2, "fbankname");
            return (Criteria) this;
        }

        public Criteria andFbanknoIsNull() {
            addCriterion("fBankNO is null");
            return (Criteria) this;
        }

        public Criteria andFbanknoIsNotNull() {
            addCriterion("fBankNO is not null");
            return (Criteria) this;
        }

        public Criteria andFbanknoEqualTo(String value) {
            addCriterion("fBankNO =", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoNotEqualTo(String value) {
            addCriterion("fBankNO <>", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoGreaterThan(String value) {
            addCriterion("fBankNO >", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoGreaterThanOrEqualTo(String value) {
            addCriterion("fBankNO >=", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoLessThan(String value) {
            addCriterion("fBankNO <", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoLessThanOrEqualTo(String value) {
            addCriterion("fBankNO <=", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoLike(String value) {
            addCriterion("fBankNO like", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoNotLike(String value) {
            addCriterion("fBankNO not like", value, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoIn(List<String> values) {
            addCriterion("fBankNO in", values, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoNotIn(List<String> values) {
            addCriterion("fBankNO not in", values, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoBetween(String value1, String value2) {
            addCriterion("fBankNO between", value1, value2, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbanknoNotBetween(String value1, String value2) {
            addCriterion("fBankNO not between", value1, value2, "fbankno");
            return (Criteria) this;
        }

        public Criteria andFbankidIsNull() {
            addCriterion("fBankID is null");
            return (Criteria) this;
        }

        public Criteria andFbankidIsNotNull() {
            addCriterion("fBankID is not null");
            return (Criteria) this;
        }

        public Criteria andFbankidEqualTo(Integer value) {
            addCriterion("fBankID =", value, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidNotEqualTo(Integer value) {
            addCriterion("fBankID <>", value, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidGreaterThan(Integer value) {
            addCriterion("fBankID >", value, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fBankID >=", value, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidLessThan(Integer value) {
            addCriterion("fBankID <", value, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidLessThanOrEqualTo(Integer value) {
            addCriterion("fBankID <=", value, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidIn(List<Integer> values) {
            addCriterion("fBankID in", values, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidNotIn(List<Integer> values) {
            addCriterion("fBankID not in", values, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidBetween(Integer value1, Integer value2) {
            addCriterion("fBankID between", value1, value2, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFbankidNotBetween(Integer value1, Integer value2) {
            addCriterion("fBankID not between", value1, value2, "fbankid");
            return (Criteria) this;
        }

        public Criteria andFoverduesumIsNull() {
            addCriterion("fOverdueSum is null");
            return (Criteria) this;
        }

        public Criteria andFoverduesumIsNotNull() {
            addCriterion("fOverdueSum is not null");
            return (Criteria) this;
        }

        public Criteria andFoverduesumEqualTo(BigDecimal value) {
            addCriterion("fOverdueSum =", value, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumNotEqualTo(BigDecimal value) {
            addCriterion("fOverdueSum <>", value, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumGreaterThan(BigDecimal value) {
            addCriterion("fOverdueSum >", value, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fOverdueSum >=", value, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumLessThan(BigDecimal value) {
            addCriterion("fOverdueSum <", value, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fOverdueSum <=", value, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumIn(List<BigDecimal> values) {
            addCriterion("fOverdueSum in", values, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumNotIn(List<BigDecimal> values) {
            addCriterion("fOverdueSum not in", values, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fOverdueSum between", value1, value2, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFoverduesumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fOverdueSum not between", value1, value2, "foverduesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumIsNull() {
            addCriterion("fFineSum is null");
            return (Criteria) this;
        }

        public Criteria andFfinesumIsNotNull() {
            addCriterion("fFineSum is not null");
            return (Criteria) this;
        }

        public Criteria andFfinesumEqualTo(BigDecimal value) {
            addCriterion("fFineSum =", value, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumNotEqualTo(BigDecimal value) {
            addCriterion("fFineSum <>", value, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumGreaterThan(BigDecimal value) {
            addCriterion("fFineSum >", value, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fFineSum >=", value, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumLessThan(BigDecimal value) {
            addCriterion("fFineSum <", value, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fFineSum <=", value, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumIn(List<BigDecimal> values) {
            addCriterion("fFineSum in", values, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumNotIn(List<BigDecimal> values) {
            addCriterion("fFineSum not in", values, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fFineSum between", value1, value2, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFfinesumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fFineSum not between", value1, value2, "ffinesum");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalIsNull() {
            addCriterion("fBalacneTotal is null");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalIsNotNull() {
            addCriterion("fBalacneTotal is not null");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalEqualTo(BigDecimal value) {
            addCriterion("fBalacneTotal =", value, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalNotEqualTo(BigDecimal value) {
            addCriterion("fBalacneTotal <>", value, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalGreaterThan(BigDecimal value) {
            addCriterion("fBalacneTotal >", value, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fBalacneTotal >=", value, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalLessThan(BigDecimal value) {
            addCriterion("fBalacneTotal <", value, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fBalacneTotal <=", value, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalIn(List<BigDecimal> values) {
            addCriterion("fBalacneTotal in", values, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalNotIn(List<BigDecimal> values) {
            addCriterion("fBalacneTotal not in", values, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fBalacneTotal between", value1, value2, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFbalacnetotalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fBalacneTotal not between", value1, value2, "fbalacnetotal");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNull() {
            addCriterion("fRelationID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationidIsNotNull() {
            addCriterion("fRelationID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationidEqualTo(Integer value) {
            addCriterion("fRelationID =", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotEqualTo(Integer value) {
            addCriterion("fRelationID <>", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThan(Integer value) {
            addCriterion("fRelationID >", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationID >=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThan(Integer value) {
            addCriterion("fRelationID <", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationID <=", value, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidIn(List<Integer> values) {
            addCriterion("fRelationID in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotIn(List<Integer> values) {
            addCriterion("fRelationID not in", values, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationID not between", value1, value2, "frelationid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNull() {
            addCriterion("fRelationClassID is null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIsNotNull() {
            addCriterion("fRelationClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidEqualTo(Integer value) {
            addCriterion("fRelationClassID =", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotEqualTo(Integer value) {
            addCriterion("fRelationClassID <>", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThan(Integer value) {
            addCriterion("fRelationClassID >", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID >=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThan(Integer value) {
            addCriterion("fRelationClassID <", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fRelationClassID <=", value, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidIn(List<Integer> values) {
            addCriterion("fRelationClassID in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotIn(List<Integer> values) {
            addCriterion("fRelationClassID not in", values, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFrelationclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fRelationClassID not between", value1, value2, "frelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusIsNull() {
            addCriterion("fIsDistrCorpus is null");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusIsNotNull() {
            addCriterion("fIsDistrCorpus is not null");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusEqualTo_back(Boolean value) {
            addCriterion("fIsDistrCorpus =", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusNotEqualTo_back(Boolean value) {
            addCriterion("fIsDistrCorpus <>", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusGreaterThan_back(Boolean value) {
            addCriterion("fIsDistrCorpus >", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrCorpus >=", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusLessThan_back(Boolean value) {
            addCriterion("fIsDistrCorpus <", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrCorpus <=", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusIn(List<Boolean> values) {
            addCriterion("fIsDistrCorpus in", values, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusNotIn(List<Boolean> values) {
            addCriterion("fIsDistrCorpus not in", values, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrCorpus between", value1, value2, "fisdistrcorpus");
            return (Criteria) this;
        }

        private Criteria andFisdistrcorpusNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrCorpus not between", value1, value2, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestIsNull() {
            addCriterion("fIsDistrInterest is null");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestIsNotNull() {
            addCriterion("fIsDistrInterest is not null");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestEqualTo_back(Boolean value) {
            addCriterion("fIsDistrInterest =", value, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestNotEqualTo_back(Boolean value) {
            addCriterion("fIsDistrInterest <>", value, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestGreaterThan_back(Boolean value) {
            addCriterion("fIsDistrInterest >", value, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrInterest >=", value, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestLessThan_back(Boolean value) {
            addCriterion("fIsDistrInterest <", value, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrInterest <=", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestIn(List<Boolean> values) {
            addCriterion("fIsDistrInterest in", values, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestNotIn(List<Boolean> values) {
            addCriterion("fIsDistrInterest not in", values, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrInterest between", value1, value2, "fisdistrinterest");
            return (Criteria) this;
        }

        private Criteria andFisdistrinterestNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrInterest not between", value1, value2, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeIsNull() {
            addCriterion("fIsDistrLateFee is null");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeIsNotNull() {
            addCriterion("fIsDistrLateFee is not null");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeEqualTo_back(Boolean value) {
            addCriterion("fIsDistrLateFee =", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeNotEqualTo_back(Boolean value) {
            addCriterion("fIsDistrLateFee <>", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeGreaterThan_back(Boolean value) {
            addCriterion("fIsDistrLateFee >", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrLateFee >=", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeLessThan_back(Boolean value) {
            addCriterion("fIsDistrLateFee <", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrLateFee <=", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeIn(List<Boolean> values) {
            addCriterion("fIsDistrLateFee in", values, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeNotIn(List<Boolean> values) {
            addCriterion("fIsDistrLateFee not in", values, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrLateFee between", value1, value2, "fisdistrlatefee");
            return (Criteria) this;
        }

        private Criteria andFisdistrlatefeeNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrLateFee not between", value1, value2, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalIsNull() {
            addCriterion("fIsDistrTotal is null");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalIsNotNull() {
            addCriterion("fIsDistrTotal is not null");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalEqualTo_back(Boolean value) {
            addCriterion("fIsDistrTotal =", value, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalNotEqualTo_back(Boolean value) {
            addCriterion("fIsDistrTotal <>", value, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalGreaterThan_back(Boolean value) {
            addCriterion("fIsDistrTotal >", value, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrTotal >=", value, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalLessThan_back(Boolean value) {
            addCriterion("fIsDistrTotal <", value, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fIsDistrTotal <=", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalIn(List<Boolean> values) {
            addCriterion("fIsDistrTotal in", values, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalNotIn(List<Boolean> values) {
            addCriterion("fIsDistrTotal not in", values, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrTotal between", value1, value2, "fisdistrtotal");
            return (Criteria) this;
        }

        private Criteria andFisdistrtotalNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fIsDistrTotal not between", value1, value2, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalIsNull() {
            addCriterion("fDistrTotal is null");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalIsNotNull() {
            addCriterion("fDistrTotal is not null");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalEqualTo(BigDecimal value) {
            addCriterion("fDistrTotal =", value, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalNotEqualTo(BigDecimal value) {
            addCriterion("fDistrTotal <>", value, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalGreaterThan(BigDecimal value) {
            addCriterion("fDistrTotal >", value, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fDistrTotal >=", value, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalLessThan(BigDecimal value) {
            addCriterion("fDistrTotal <", value, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fDistrTotal <=", value, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalIn(List<BigDecimal> values) {
            addCriterion("fDistrTotal in", values, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalNotIn(List<BigDecimal> values) {
            addCriterion("fDistrTotal not in", values, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fDistrTotal between", value1, value2, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFdistrtotalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fDistrTotal not between", value1, value2, "fdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIsNull() {
            addCriterion("fCreatorID is null");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIsNotNull() {
            addCriterion("fCreatorID is not null");
            return (Criteria) this;
        }

        public Criteria andFcreatoridEqualTo(Integer value) {
            addCriterion("fCreatorID =", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotEqualTo(Integer value) {
            addCriterion("fCreatorID <>", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridGreaterThan(Integer value) {
            addCriterion("fCreatorID >", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCreatorID >=", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridLessThan(Integer value) {
            addCriterion("fCreatorID <", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridLessThanOrEqualTo(Integer value) {
            addCriterion("fCreatorID <=", value, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridIn(List<Integer> values) {
            addCriterion("fCreatorID in", values, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotIn(List<Integer> values) {
            addCriterion("fCreatorID not in", values, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridBetween(Integer value1, Integer value2) {
            addCriterion("fCreatorID between", value1, value2, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFcreatoridNotBetween(Integer value1, Integer value2) {
            addCriterion("fCreatorID not between", value1, value2, "fcreatorid");
            return (Criteria) this;
        }

        public Criteria andFmenderidIsNull() {
            addCriterion("fMenderID is null");
            return (Criteria) this;
        }

        public Criteria andFmenderidIsNotNull() {
            addCriterion("fMenderID is not null");
            return (Criteria) this;
        }

        public Criteria andFmenderidEqualTo(Integer value) {
            addCriterion("fMenderID =", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotEqualTo(Integer value) {
            addCriterion("fMenderID <>", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidGreaterThan(Integer value) {
            addCriterion("fMenderID >", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMenderID >=", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidLessThan(Integer value) {
            addCriterion("fMenderID <", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidLessThanOrEqualTo(Integer value) {
            addCriterion("fMenderID <=", value, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidIn(List<Integer> values) {
            addCriterion("fMenderID in", values, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotIn(List<Integer> values) {
            addCriterion("fMenderID not in", values, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidBetween(Integer value1, Integer value2) {
            addCriterion("fMenderID between", value1, value2, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFmenderidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMenderID not between", value1, value2, "fmenderid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIsNull() {
            addCriterion("fCheckerID is null");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIsNotNull() {
            addCriterion("fCheckerID is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckeridEqualTo(Integer value) {
            addCriterion("fCheckerID =", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotEqualTo(Integer value) {
            addCriterion("fCheckerID <>", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridGreaterThan(Integer value) {
            addCriterion("fCheckerID >", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCheckerID >=", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridLessThan(Integer value) {
            addCriterion("fCheckerID <", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridLessThanOrEqualTo(Integer value) {
            addCriterion("fCheckerID <=", value, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridIn(List<Integer> values) {
            addCriterion("fCheckerID in", values, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotIn(List<Integer> values) {
            addCriterion("fCheckerID not in", values, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridBetween(Integer value1, Integer value2) {
            addCriterion("fCheckerID between", value1, value2, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcheckeridNotBetween(Integer value1, Integer value2) {
            addCriterion("fCheckerID not between", value1, value2, "fcheckerid");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIsNull() {
            addCriterion("fCreateDate is null");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIsNotNull() {
            addCriterion("fCreateDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcreatedateEqualTo(Date value) {
            addCriterion("fCreateDate =", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotEqualTo(Date value) {
            addCriterion("fCreateDate <>", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateGreaterThan(Date value) {
            addCriterion("fCreateDate >", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCreateDate >=", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateLessThan(Date value) {
            addCriterion("fCreateDate <", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateLessThanOrEqualTo(Date value) {
            addCriterion("fCreateDate <=", value, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateIn(List<Date> values) {
            addCriterion("fCreateDate in", values, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotIn(List<Date> values) {
            addCriterion("fCreateDate not in", values, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateBetween(Date value1, Date value2) {
            addCriterion("fCreateDate between", value1, value2, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFcreatedateNotBetween(Date value1, Date value2) {
            addCriterion("fCreateDate not between", value1, value2, "fcreatedate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIsNull() {
            addCriterion("fModifyDate is null");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIsNotNull() {
            addCriterion("fModifyDate is not null");
            return (Criteria) this;
        }

        public Criteria andFmodifydateEqualTo(Date value) {
            addCriterion("fModifyDate =", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotEqualTo(Date value) {
            addCriterion("fModifyDate <>", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateGreaterThan(Date value) {
            addCriterion("fModifyDate >", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateGreaterThanOrEqualTo(Date value) {
            addCriterion("fModifyDate >=", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateLessThan(Date value) {
            addCriterion("fModifyDate <", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateLessThanOrEqualTo(Date value) {
            addCriterion("fModifyDate <=", value, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateIn(List<Date> values) {
            addCriterion("fModifyDate in", values, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotIn(List<Date> values) {
            addCriterion("fModifyDate not in", values, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateBetween(Date value1, Date value2) {
            addCriterion("fModifyDate between", value1, value2, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFmodifydateNotBetween(Date value1, Date value2) {
            addCriterion("fModifyDate not between", value1, value2, "fmodifydate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateIsNull() {
            addCriterion("fCheckerDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateIsNotNull() {
            addCriterion("fCheckerDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateEqualTo(Date value) {
            addCriterion("fCheckerDate =", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateNotEqualTo(Date value) {
            addCriterion("fCheckerDate <>", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateGreaterThan(Date value) {
            addCriterion("fCheckerDate >", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckerDate >=", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateLessThan(Date value) {
            addCriterion("fCheckerDate <", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckerDate <=", value, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateIn(List<Date> values) {
            addCriterion("fCheckerDate in", values, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateNotIn(List<Date> values) {
            addCriterion("fCheckerDate not in", values, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateBetween(Date value1, Date value2) {
            addCriterion("fCheckerDate between", value1, value2, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckerdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckerDate not between", value1, value2, "fcheckerdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNull() {
            addCriterion("fCheckDate is null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIsNotNull() {
            addCriterion("fCheckDate is not null");
            return (Criteria) this;
        }

        public Criteria andFcheckdateEqualTo(Date value) {
            addCriterion("fCheckDate =", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotEqualTo(Date value) {
            addCriterion("fCheckDate <>", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThan(Date value) {
            addCriterion("fCheckDate >", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateGreaterThanOrEqualTo(Date value) {
            addCriterion("fCheckDate >=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThan(Date value) {
            addCriterion("fCheckDate <", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateLessThanOrEqualTo(Date value) {
            addCriterion("fCheckDate <=", value, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateIn(List<Date> values) {
            addCriterion("fCheckDate in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotIn(List<Date> values) {
            addCriterion("fCheckDate not in", values, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateBetween(Date value1, Date value2) {
            addCriterion("fCheckDate between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcheckdateNotBetween(Date value1, Date value2) {
            addCriterion("fCheckDate not between", value1, value2, "fcheckdate");
            return (Criteria) this;
        }

        public Criteria andFcitemidIsNull() {
            addCriterion("fCItemID is null");
            return (Criteria) this;
        }

        public Criteria andFcitemidIsNotNull() {
            addCriterion("fCItemID is not null");
            return (Criteria) this;
        }

        public Criteria andFcitemidEqualTo(Integer value) {
            addCriterion("fCItemID =", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidNotEqualTo(Integer value) {
            addCriterion("fCItemID <>", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidGreaterThan(Integer value) {
            addCriterion("fCItemID >", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fCItemID >=", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidLessThan(Integer value) {
            addCriterion("fCItemID <", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidLessThanOrEqualTo(Integer value) {
            addCriterion("fCItemID <=", value, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidIn(List<Integer> values) {
            addCriterion("fCItemID in", values, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidNotIn(List<Integer> values) {
            addCriterion("fCItemID not in", values, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidBetween(Integer value1, Integer value2) {
            addCriterion("fCItemID between", value1, value2, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFcitemidNotBetween(Integer value1, Integer value2) {
            addCriterion("fCItemID not between", value1, value2, "fcitemid");
            return (Criteria) this;
        }

        public Criteria andFmachineidIsNull() {
            addCriterion("fMachineID is null");
            return (Criteria) this;
        }

        public Criteria andFmachineidIsNotNull() {
            addCriterion("fMachineID is not null");
            return (Criteria) this;
        }

        public Criteria andFmachineidEqualTo(Integer value) {
            addCriterion("fMachineID =", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidNotEqualTo(Integer value) {
            addCriterion("fMachineID <>", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidGreaterThan(Integer value) {
            addCriterion("fMachineID >", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fMachineID >=", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidLessThan(Integer value) {
            addCriterion("fMachineID <", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidLessThanOrEqualTo(Integer value) {
            addCriterion("fMachineID <=", value, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidIn(List<Integer> values) {
            addCriterion("fMachineID in", values, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidNotIn(List<Integer> values) {
            addCriterion("fMachineID not in", values, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidBetween(Integer value1, Integer value2) {
            addCriterion("fMachineID between", value1, value2, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFmachineidNotBetween(Integer value1, Integer value2) {
            addCriterion("fMachineID not between", value1, value2, "fmachineid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidIsNull() {
            addCriterion("fSaleModeID is null");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidIsNotNull() {
            addCriterion("fSaleModeID is not null");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidEqualTo(Integer value) {
            addCriterion("fSaleModeID =", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidNotEqualTo(Integer value) {
            addCriterion("fSaleModeID <>", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidGreaterThan(Integer value) {
            addCriterion("fSaleModeID >", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fSaleModeID >=", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidLessThan(Integer value) {
            addCriterion("fSaleModeID <", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidLessThanOrEqualTo(Integer value) {
            addCriterion("fSaleModeID <=", value, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidIn(List<Integer> values) {
            addCriterion("fSaleModeID in", values, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidNotIn(List<Integer> values) {
            addCriterion("fSaleModeID not in", values, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidBetween(Integer value1, Integer value2) {
            addCriterion("fSaleModeID between", value1, value2, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFsalemodeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fSaleModeID not between", value1, value2, "fsalemodeid");
            return (Criteria) this;
        }

        public Criteria andFcorpussumIsNull() {
            addCriterion("fCorpusSum is null");
            return (Criteria) this;
        }

        public Criteria andFcorpussumIsNotNull() {
            addCriterion("fCorpusSum is not null");
            return (Criteria) this;
        }

        public Criteria andFcorpussumEqualTo(BigDecimal value) {
            addCriterion("fCorpusSum =", value, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumNotEqualTo(BigDecimal value) {
            addCriterion("fCorpusSum <>", value, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumGreaterThan(BigDecimal value) {
            addCriterion("fCorpusSum >", value, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fCorpusSum >=", value, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumLessThan(BigDecimal value) {
            addCriterion("fCorpusSum <", value, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fCorpusSum <=", value, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumIn(List<BigDecimal> values) {
            addCriterion("fCorpusSum in", values, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumNotIn(List<BigDecimal> values) {
            addCriterion("fCorpusSum not in", values, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fCorpusSum between", value1, value2, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFcorpussumNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fCorpusSum not between", value1, value2, "fcorpussum");
            return (Criteria) this;
        }

        public Criteria andFperiodunitIsNull() {
            addCriterion("fPeriodUnit is null");
            return (Criteria) this;
        }

        public Criteria andFperiodunitIsNotNull() {
            addCriterion("fPeriodUnit is not null");
            return (Criteria) this;
        }

        public Criteria andFperiodunitEqualTo(Integer value) {
            addCriterion("fPeriodUnit =", value, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitNotEqualTo(Integer value) {
            addCriterion("fPeriodUnit <>", value, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitGreaterThan(Integer value) {
            addCriterion("fPeriodUnit >", value, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPeriodUnit >=", value, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitLessThan(Integer value) {
            addCriterion("fPeriodUnit <", value, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitLessThanOrEqualTo(Integer value) {
            addCriterion("fPeriodUnit <=", value, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitIn(List<Integer> values) {
            addCriterion("fPeriodUnit in", values, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitNotIn(List<Integer> values) {
            addCriterion("fPeriodUnit not in", values, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitBetween(Integer value1, Integer value2) {
            addCriterion("fPeriodUnit between", value1, value2, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodunitNotBetween(Integer value1, Integer value2) {
            addCriterion("fPeriodUnit not between", value1, value2, "fperiodunit");
            return (Criteria) this;
        }

        public Criteria andFperiodsumIsNull() {
            addCriterion("fPeriodSum is null");
            return (Criteria) this;
        }

        public Criteria andFperiodsumIsNotNull() {
            addCriterion("fPeriodSum is not null");
            return (Criteria) this;
        }

        public Criteria andFperiodsumEqualTo(Integer value) {
            addCriterion("fPeriodSum =", value, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumNotEqualTo(Integer value) {
            addCriterion("fPeriodSum <>", value, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumGreaterThan(Integer value) {
            addCriterion("fPeriodSum >", value, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPeriodSum >=", value, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumLessThan(Integer value) {
            addCriterion("fPeriodSum <", value, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumLessThanOrEqualTo(Integer value) {
            addCriterion("fPeriodSum <=", value, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumIn(List<Integer> values) {
            addCriterion("fPeriodSum in", values, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumNotIn(List<Integer> values) {
            addCriterion("fPeriodSum not in", values, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumBetween(Integer value1, Integer value2) {
            addCriterion("fPeriodSum between", value1, value2, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFperiodsumNotBetween(Integer value1, Integer value2) {
            addCriterion("fPeriodSum not between", value1, value2, "fperiodsum");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidIsNull() {
            addCriterion("fReturnFundModeID is null");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidIsNotNull() {
            addCriterion("fReturnFundModeID is not null");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidEqualTo(Integer value) {
            addCriterion("fReturnFundModeID =", value, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidNotEqualTo(Integer value) {
            addCriterion("fReturnFundModeID <>", value, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidGreaterThan(Integer value) {
            addCriterion("fReturnFundModeID >", value, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fReturnFundModeID >=", value, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidLessThan(Integer value) {
            addCriterion("fReturnFundModeID <", value, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidLessThanOrEqualTo(Integer value) {
            addCriterion("fReturnFundModeID <=", value, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidIn(List<Integer> values) {
            addCriterion("fReturnFundModeID in", values, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidNotIn(List<Integer> values) {
            addCriterion("fReturnFundModeID not in", values, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidBetween(Integer value1, Integer value2) {
            addCriterion("fReturnFundModeID between", value1, value2, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFreturnfundmodeidNotBetween(Integer value1, Integer value2) {
            addCriterion("fReturnFundModeID not between", value1, value2, "freturnfundmodeid");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusIsNull() {
            addCriterion("fPeriodModulus is null");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusIsNotNull() {
            addCriterion("fPeriodModulus is not null");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusEqualTo(Integer value) {
            addCriterion("fPeriodModulus =", value, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusNotEqualTo(Integer value) {
            addCriterion("fPeriodModulus <>", value, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusGreaterThan(Integer value) {
            addCriterion("fPeriodModulus >", value, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusGreaterThanOrEqualTo(Integer value) {
            addCriterion("fPeriodModulus >=", value, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusLessThan(Integer value) {
            addCriterion("fPeriodModulus <", value, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusLessThanOrEqualTo(Integer value) {
            addCriterion("fPeriodModulus <=", value, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusIn(List<Integer> values) {
            addCriterion("fPeriodModulus in", values, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusNotIn(List<Integer> values) {
            addCriterion("fPeriodModulus not in", values, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusBetween(Integer value1, Integer value2) {
            addCriterion("fPeriodModulus between", value1, value2, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFperiodmodulusNotBetween(Integer value1, Integer value2) {
            addCriterion("fPeriodModulus not between", value1, value2, "fperiodmodulus");
            return (Criteria) this;
        }

        public Criteria andFloaddateIsNull() {
            addCriterion("fLoadDate is null");
            return (Criteria) this;
        }

        public Criteria andFloaddateIsNotNull() {
            addCriterion("fLoadDate is not null");
            return (Criteria) this;
        }

        public Criteria andFloaddateEqualTo(Date value) {
            addCriterion("fLoadDate =", value, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateNotEqualTo(Date value) {
            addCriterion("fLoadDate <>", value, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateGreaterThan(Date value) {
            addCriterion("fLoadDate >", value, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateGreaterThanOrEqualTo(Date value) {
            addCriterion("fLoadDate >=", value, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateLessThan(Date value) {
            addCriterion("fLoadDate <", value, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateLessThanOrEqualTo(Date value) {
            addCriterion("fLoadDate <=", value, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateIn(List<Date> values) {
            addCriterion("fLoadDate in", values, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateNotIn(List<Date> values) {
            addCriterion("fLoadDate not in", values, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateBetween(Date value1, Date value2) {
            addCriterion("fLoadDate between", value1, value2, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFloaddateNotBetween(Date value1, Date value2) {
            addCriterion("fLoadDate not between", value1, value2, "floaddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateIsNull() {
            addCriterion("fPlanEndDate is null");
            return (Criteria) this;
        }

        public Criteria andFplanenddateIsNotNull() {
            addCriterion("fPlanEndDate is not null");
            return (Criteria) this;
        }

        public Criteria andFplanenddateEqualTo(Date value) {
            addCriterion("fPlanEndDate =", value, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateNotEqualTo(Date value) {
            addCriterion("fPlanEndDate <>", value, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateGreaterThan(Date value) {
            addCriterion("fPlanEndDate >", value, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateGreaterThanOrEqualTo(Date value) {
            addCriterion("fPlanEndDate >=", value, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateLessThan(Date value) {
            addCriterion("fPlanEndDate <", value, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateLessThanOrEqualTo(Date value) {
            addCriterion("fPlanEndDate <=", value, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateIn(List<Date> values) {
            addCriterion("fPlanEndDate in", values, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateNotIn(List<Date> values) {
            addCriterion("fPlanEndDate not in", values, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateBetween(Date value1, Date value2) {
            addCriterion("fPlanEndDate between", value1, value2, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFplanenddateNotBetween(Date value1, Date value2) {
            addCriterion("fPlanEndDate not between", value1, value2, "fplanenddate");
            return (Criteria) this;
        }

        public Criteria andFrateIsNull() {
            addCriterion("fRate is null");
            return (Criteria) this;
        }

        public Criteria andFrateIsNotNull() {
            addCriterion("fRate is not null");
            return (Criteria) this;
        }

        public Criteria andFrateEqualTo(BigDecimal value) {
            addCriterion("fRate =", value, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateNotEqualTo(BigDecimal value) {
            addCriterion("fRate <>", value, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateGreaterThan(BigDecimal value) {
            addCriterion("fRate >", value, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fRate >=", value, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateLessThan(BigDecimal value) {
            addCriterion("fRate <", value, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fRate <=", value, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateIn(List<BigDecimal> values) {
            addCriterion("fRate in", values, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateNotIn(List<BigDecimal> values) {
            addCriterion("fRate not in", values, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fRate between", value1, value2, "frate");
            return (Criteria) this;
        }

        public Criteria andFrateNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fRate not between", value1, value2, "frate");
            return (Criteria) this;
        }

        public Criteria andFbitIsNull() {
            addCriterion("fBit is null");
            return (Criteria) this;
        }

        public Criteria andFbitIsNotNull() {
            addCriterion("fBit is not null");
            return (Criteria) this;
        }

        private Criteria andFbitEqualTo_back(Boolean value) {
            addCriterion("fBit =", value, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitNotEqualTo_back(Boolean value) {
            addCriterion("fBit <>", value, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitGreaterThan_back(Boolean value) {
            addCriterion("fBit >", value, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fBit >=", value, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitLessThan_back(Boolean value) {
            addCriterion("fBit <", value, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fBit <=", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitIn(List<Boolean> values) {
            addCriterion("fBit in", values, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitNotIn(List<Boolean> values) {
            addCriterion("fBit not in", values, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fBit between", value1, value2, "fbit");
            return (Criteria) this;
        }

        private Criteria andFbitNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fBit not between", value1, value2, "fbit");
            return (Criteria) this;
        }

        public Criteria andF186542IsNull() {
            addCriterion("f186542 is null");
            return (Criteria) this;
        }

        public Criteria andF186542IsNotNull() {
            addCriterion("f186542 is not null");
            return (Criteria) this;
        }

        public Criteria andF186542EqualTo(String value) {
            addCriterion("f186542 =", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542NotEqualTo(String value) {
            addCriterion("f186542 <>", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542GreaterThan(String value) {
            addCriterion("f186542 >", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542GreaterThanOrEqualTo(String value) {
            addCriterion("f186542 >=", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542LessThan(String value) {
            addCriterion("f186542 <", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542LessThanOrEqualTo(String value) {
            addCriterion("f186542 <=", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542Like(String value) {
            addCriterion("f186542 like", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542NotLike(String value) {
            addCriterion("f186542 not like", value, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542In(List<String> values) {
            addCriterion("f186542 in", values, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542NotIn(List<String> values) {
            addCriterion("f186542 not in", values, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542Between(String value1, String value2) {
            addCriterion("f186542 between", value1, value2, "f186542");
            return (Criteria) this;
        }

        public Criteria andF186542NotBetween(String value1, String value2) {
            addCriterion("f186542 not between", value1, value2, "f186542");
            return (Criteria) this;
        }

        public Criteria andFbanknoidIsNull() {
            addCriterion("fBankNOID is null");
            return (Criteria) this;
        }

        public Criteria andFbanknoidIsNotNull() {
            addCriterion("fBankNOID is not null");
            return (Criteria) this;
        }

        public Criteria andFbanknoidEqualTo(Integer value) {
            addCriterion("fBankNOID =", value, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidNotEqualTo(Integer value) {
            addCriterion("fBankNOID <>", value, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidGreaterThan(Integer value) {
            addCriterion("fBankNOID >", value, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fBankNOID >=", value, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidLessThan(Integer value) {
            addCriterion("fBankNOID <", value, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidLessThanOrEqualTo(Integer value) {
            addCriterion("fBankNOID <=", value, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidIn(List<Integer> values) {
            addCriterion("fBankNOID in", values, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidNotIn(List<Integer> values) {
            addCriterion("fBankNOID not in", values, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidBetween(Integer value1, Integer value2) {
            addCriterion("fBankNOID between", value1, value2, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFbanknoidNotBetween(Integer value1, Integer value2) {
            addCriterion("fBankNOID not between", value1, value2, "fbanknoid");
            return (Criteria) this;
        }

        public Criteria andFthistotalIsNull() {
            addCriterion("fThisTotal is null");
            return (Criteria) this;
        }

        public Criteria andFthistotalIsNotNull() {
            addCriterion("fThisTotal is not null");
            return (Criteria) this;
        }

        public Criteria andFthistotalEqualTo(BigDecimal value) {
            addCriterion("fThisTotal =", value, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalNotEqualTo(BigDecimal value) {
            addCriterion("fThisTotal <>", value, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalGreaterThan(BigDecimal value) {
            addCriterion("fThisTotal >", value, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("fThisTotal >=", value, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalLessThan(BigDecimal value) {
            addCriterion("fThisTotal <", value, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalLessThanOrEqualTo(BigDecimal value) {
            addCriterion("fThisTotal <=", value, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalIn(List<BigDecimal> values) {
            addCriterion("fThisTotal in", values, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalNotIn(List<BigDecimal> values) {
            addCriterion("fThisTotal not in", values, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fThisTotal between", value1, value2, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFthistotalNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("fThisTotal not between", value1, value2, "fthistotal");
            return (Criteria) this;
        }

        public Criteria andFisRelationidIsNull() {
            addCriterion("fIs_RelationID is null");
            return (Criteria) this;
        }

        public Criteria andFisRelationidIsNotNull() {
            addCriterion("fIs_RelationID is not null");
            return (Criteria) this;
        }

        public Criteria andFisRelationidEqualTo(Integer value) {
            addCriterion("fIs_RelationID =", value, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidNotEqualTo(Integer value) {
            addCriterion("fIs_RelationID <>", value, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidGreaterThan(Integer value) {
            addCriterion("fIs_RelationID >", value, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fIs_RelationID >=", value, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidLessThan(Integer value) {
            addCriterion("fIs_RelationID <", value, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidLessThanOrEqualTo(Integer value) {
            addCriterion("fIs_RelationID <=", value, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidIn(List<Integer> values) {
            addCriterion("fIs_RelationID in", values, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidNotIn(List<Integer> values) {
            addCriterion("fIs_RelationID not in", values, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidBetween(Integer value1, Integer value2) {
            addCriterion("fIs_RelationID between", value1, value2, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationidNotBetween(Integer value1, Integer value2) {
            addCriterion("fIs_RelationID not between", value1, value2, "fisRelationid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidIsNull() {
            addCriterion("fIs_RelationClassID is null");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidIsNotNull() {
            addCriterion("fIs_RelationClassID is not null");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidEqualTo(Integer value) {
            addCriterion("fIs_RelationClassID =", value, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidNotEqualTo(Integer value) {
            addCriterion("fIs_RelationClassID <>", value, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidGreaterThan(Integer value) {
            addCriterion("fIs_RelationClassID >", value, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fIs_RelationClassID >=", value, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidLessThan(Integer value) {
            addCriterion("fIs_RelationClassID <", value, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidLessThanOrEqualTo(Integer value) {
            addCriterion("fIs_RelationClassID <=", value, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidIn(List<Integer> values) {
            addCriterion("fIs_RelationClassID in", values, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidNotIn(List<Integer> values) {
            addCriterion("fIs_RelationClassID not in", values, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidBetween(Integer value1, Integer value2) {
            addCriterion("fIs_RelationClassID between", value1, value2, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFisRelationclassidNotBetween(Integer value1, Integer value2) {
            addCriterion("fIs_RelationClassID not between", value1, value2, "fisRelationclassid");
            return (Criteria) this;
        }

        public Criteria andFdnidIsNull() {
            addCriterion("fDNID is null");
            return (Criteria) this;
        }

        public Criteria andFdnidIsNotNull() {
            addCriterion("fDNID is not null");
            return (Criteria) this;
        }

        public Criteria andFdnidEqualTo(Integer value) {
            addCriterion("fDNID =", value, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidNotEqualTo(Integer value) {
            addCriterion("fDNID <>", value, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidGreaterThan(Integer value) {
            addCriterion("fDNID >", value, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fDNID >=", value, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidLessThan(Integer value) {
            addCriterion("fDNID <", value, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidLessThanOrEqualTo(Integer value) {
            addCriterion("fDNID <=", value, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidIn(List<Integer> values) {
            addCriterion("fDNID in", values, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidNotIn(List<Integer> values) {
            addCriterion("fDNID not in", values, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidBetween(Integer value1, Integer value2) {
            addCriterion("fDNID between", value1, value2, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFdnidNotBetween(Integer value1, Integer value2) {
            addCriterion("fDNID not between", value1, value2, "fdnid");
            return (Criteria) this;
        }

        public Criteria andFplIsNull() {
            addCriterion("fPL is null");
            return (Criteria) this;
        }

        public Criteria andFplIsNotNull() {
            addCriterion("fPL is not null");
            return (Criteria) this;
        }

        private Criteria andFplEqualTo_back(Boolean value) {
            addCriterion("fPL =", value, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplNotEqualTo_back(Boolean value) {
            addCriterion("fPL <>", value, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplGreaterThan_back(Boolean value) {
            addCriterion("fPL >", value, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplGreaterThanOrEqualTo_back(Boolean value) {
            addCriterion("fPL >=", value, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplLessThan_back(Boolean value) {
            addCriterion("fPL <", value, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplLessThanOrEqualTo_back(Boolean value) {
            addCriterion("fPL <=", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplIn(List<Boolean> values) {
            addCriterion("fPL in", values, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplNotIn(List<Boolean> values) {
            addCriterion("fPL not in", values, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fPL between", value1, value2, "fpl");
            return (Criteria) this;
        }

        private Criteria andFplNotBetween_back(Boolean value1, Boolean value2) {
            addCriterion("fPL not between", value1, value2, "fpl");
            return (Criteria) this;
        }

        public Criteria andFcostitemIsNull() {
            addCriterion("fCostItem is null");
            return (Criteria) this;
        }

        public Criteria andFcostitemIsNotNull() {
            addCriterion("fCostItem is not null");
            return (Criteria) this;
        }

        public Criteria andFcostitemEqualTo(String value) {
            addCriterion("fCostItem =", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemNotEqualTo(String value) {
            addCriterion("fCostItem <>", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemGreaterThan(String value) {
            addCriterion("fCostItem >", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemGreaterThanOrEqualTo(String value) {
            addCriterion("fCostItem >=", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemLessThan(String value) {
            addCriterion("fCostItem <", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemLessThanOrEqualTo(String value) {
            addCriterion("fCostItem <=", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemLike(String value) {
            addCriterion("fCostItem like", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemNotLike(String value) {
            addCriterion("fCostItem not like", value, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemIn(List<String> values) {
            addCriterion("fCostItem in", values, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemNotIn(List<String> values) {
            addCriterion("fCostItem not in", values, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemBetween(String value1, String value2) {
            addCriterion("fCostItem between", value1, value2, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFcostitemNotBetween(String value1, String value2) {
            addCriterion("fCostItem not between", value1, value2, "fcostitem");
            return (Criteria) this;
        }

        public Criteria andFabstractIsNull() {
            addCriterion("fAbstract is null");
            return (Criteria) this;
        }

        public Criteria andFabstractIsNotNull() {
            addCriterion("fAbstract is not null");
            return (Criteria) this;
        }

        public Criteria andFabstractEqualTo(String value) {
            addCriterion("fAbstract =", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractNotEqualTo(String value) {
            addCriterion("fAbstract <>", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractGreaterThan(String value) {
            addCriterion("fAbstract >", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractGreaterThanOrEqualTo(String value) {
            addCriterion("fAbstract >=", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractLessThan(String value) {
            addCriterion("fAbstract <", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractLessThanOrEqualTo(String value) {
            addCriterion("fAbstract <=", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractLike(String value) {
            addCriterion("fAbstract like", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractNotLike(String value) {
            addCriterion("fAbstract not like", value, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractIn(List<String> values) {
            addCriterion("fAbstract in", values, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractNotIn(List<String> values) {
            addCriterion("fAbstract not in", values, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractBetween(String value1, String value2) {
            addCriterion("fAbstract between", value1, value2, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFabstractNotBetween(String value1, String value2) {
            addCriterion("fAbstract not between", value1, value2, "fabstract");
            return (Criteria) this;
        }

        public Criteria andFbacknoIsNull() {
            addCriterion("fBackNO is null");
            return (Criteria) this;
        }

        public Criteria andFbacknoIsNotNull() {
            addCriterion("fBackNO is not null");
            return (Criteria) this;
        }

        public Criteria andFbacknoEqualTo(String value) {
            addCriterion("fBackNO =", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoNotEqualTo(String value) {
            addCriterion("fBackNO <>", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoGreaterThan(String value) {
            addCriterion("fBackNO >", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoGreaterThanOrEqualTo(String value) {
            addCriterion("fBackNO >=", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoLessThan(String value) {
            addCriterion("fBackNO <", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoLessThanOrEqualTo(String value) {
            addCriterion("fBackNO <=", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoLike(String value) {
            addCriterion("fBackNO like", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoNotLike(String value) {
            addCriterion("fBackNO not like", value, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoIn(List<String> values) {
            addCriterion("fBackNO in", values, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoNotIn(List<String> values) {
            addCriterion("fBackNO not in", values, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoBetween(String value1, String value2) {
            addCriterion("fBackNO between", value1, value2, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFbacknoNotBetween(String value1, String value2) {
            addCriterion("fBackNO not between", value1, value2, "fbackno");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidIsNull() {
            addCriterion("fThirdStatusID is null");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidIsNotNull() {
            addCriterion("fThirdStatusID is not null");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidEqualTo(Integer value) {
            addCriterion("fThirdStatusID =", value, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidNotEqualTo(Integer value) {
            addCriterion("fThirdStatusID <>", value, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidGreaterThan(Integer value) {
            addCriterion("fThirdStatusID >", value, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidGreaterThanOrEqualTo(Integer value) {
            addCriterion("fThirdStatusID >=", value, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidLessThan(Integer value) {
            addCriterion("fThirdStatusID <", value, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidLessThanOrEqualTo(Integer value) {
            addCriterion("fThirdStatusID <=", value, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidIn(List<Integer> values) {
            addCriterion("fThirdStatusID in", values, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidNotIn(List<Integer> values) {
            addCriterion("fThirdStatusID not in", values, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidBetween(Integer value1, Integer value2) {
            addCriterion("fThirdStatusID between", value1, value2, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFthirdstatusidNotBetween(Integer value1, Integer value2) {
            addCriterion("fThirdStatusID not between", value1, value2, "fthirdstatusid");
            return (Criteria) this;
        }

        public Criteria andFstatusnameIsNull() {
            addCriterion("fStatusName is null");
            return (Criteria) this;
        }

        public Criteria andFstatusnameIsNotNull() {
            addCriterion("fStatusName is not null");
            return (Criteria) this;
        }

        public Criteria andFstatusnameEqualTo(String value) {
            addCriterion("fStatusName =", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameNotEqualTo(String value) {
            addCriterion("fStatusName <>", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameGreaterThan(String value) {
            addCriterion("fStatusName >", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameGreaterThanOrEqualTo(String value) {
            addCriterion("fStatusName >=", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameLessThan(String value) {
            addCriterion("fStatusName <", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameLessThanOrEqualTo(String value) {
            addCriterion("fStatusName <=", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameLike(String value) {
            addCriterion("fStatusName like", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameNotLike(String value) {
            addCriterion("fStatusName not like", value, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameIn(List<String> values) {
            addCriterion("fStatusName in", values, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameNotIn(List<String> values) {
            addCriterion("fStatusName not in", values, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameBetween(String value1, String value2) {
            addCriterion("fStatusName between", value1, value2, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusnameNotBetween(String value1, String value2) {
            addCriterion("fStatusName not between", value1, value2, "fstatusname");
            return (Criteria) this;
        }

        public Criteria andFstatusEqualTo(int value) {
            addCriterion("fStatus =", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotEqualTo(int value) {
            addCriterion("fStatus <>", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusGreaterThan(int value) {
            addCriterion("fStatus >", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusGreaterThanOrEqualTo(int value) {
            addCriterion("fStatus >=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusLessThan(int value) {
            addCriterion("fStatus <", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusLessThanOrEqualTo(int value) {
            addCriterion("fStatus <=", value, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusBetween(int value1, int value2) {
            addCriterion("fStatus between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFstatusNotBetween(int value1, int value2) {
            addCriterion("fStatus not between", value1, value2, "fstatus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusEqualTo(int value) {
            addCriterion("fIsDistrCorpus =", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusNotEqualTo(int value) {
            addCriterion("fIsDistrCorpus <>", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusGreaterThan(int value) {
            addCriterion("fIsDistrCorpus >", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusGreaterThanOrEqualTo(int value) {
            addCriterion("fIsDistrCorpus >=", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusLessThan(int value) {
            addCriterion("fIsDistrCorpus <", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusLessThanOrEqualTo(int value) {
            addCriterion("fIsDistrCorpus <=", value, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusBetween(int value1, int value2) {
            addCriterion("fIsDistrCorpus between", value1, value2, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrcorpusNotBetween(int value1, int value2) {
            addCriterion("fIsDistrCorpus not between", value1, value2, "fisdistrcorpus");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestEqualTo(int value) {
            addCriterion("fIsDistrInterest =", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestNotEqualTo(int value) {
            addCriterion("fIsDistrInterest <>", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestGreaterThan(int value) {
            addCriterion("fIsDistrInterest >", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestGreaterThanOrEqualTo(int value) {
            addCriterion("fIsDistrInterest >=", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestLessThan(int value) {
            addCriterion("fIsDistrInterest <", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestLessThanOrEqualTo(int value) {
            addCriterion("fIsDistrInterest <=", value, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestBetween(int value1, int value2) {
            addCriterion("fIsDistrInterest between", value1, value2, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrinterestNotBetween(int value1, int value2) {
            addCriterion("fIsDistrInterest not between", value1, value2, "fisdistrinterest");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeEqualTo(int value) {
            addCriterion("fIsDistrLateFee =", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeNotEqualTo(int value) {
            addCriterion("fIsDistrLateFee <>", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeGreaterThan(int value) {
            addCriterion("fIsDistrLateFee >", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeGreaterThanOrEqualTo(int value) {
            addCriterion("fIsDistrLateFee >=", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeLessThan(int value) {
            addCriterion("fIsDistrLateFee <", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeLessThanOrEqualTo(int value) {
            addCriterion("fIsDistrLateFee <=", value, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeBetween(int value1, int value2) {
            addCriterion("fIsDistrLateFee between", value1, value2, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrlatefeeNotBetween(int value1, int value2) {
            addCriterion("fIsDistrLateFee not between", value1, value2, "fisdistrlatefee");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalEqualTo(int value) {
            addCriterion("fIsDistrTotal =", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalNotEqualTo(int value) {
            addCriterion("fIsDistrTotal <>", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalGreaterThan(int value) {
            addCriterion("fIsDistrTotal >", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalGreaterThanOrEqualTo(int value) {
            addCriterion("fIsDistrTotal >=", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalLessThan(int value) {
            addCriterion("fIsDistrTotal <", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalLessThanOrEqualTo(int value) {
            addCriterion("fIsDistrTotal <=", value, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalBetween(int value1, int value2) {
            addCriterion("fIsDistrTotal between", value1, value2, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFisdistrtotalNotBetween(int value1, int value2) {
            addCriterion("fIsDistrTotal not between", value1, value2, "fisdistrtotal");
            return (Criteria) this;
        }

        public Criteria andFbitEqualTo(int value) {
            addCriterion("fBit =", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitNotEqualTo(int value) {
            addCriterion("fBit <>", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitGreaterThan(int value) {
            addCriterion("fBit >", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitGreaterThanOrEqualTo(int value) {
            addCriterion("fBit >=", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitLessThan(int value) {
            addCriterion("fBit <", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitLessThanOrEqualTo(int value) {
            addCriterion("fBit <=", value, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitBetween(int value1, int value2) {
            addCriterion("fBit between", value1, value2, "fbit");
            return (Criteria) this;
        }

        public Criteria andFbitNotBetween(int value1, int value2) {
            addCriterion("fBit not between", value1, value2, "fbit");
            return (Criteria) this;
        }

        public Criteria andFplEqualTo(int value) {
            addCriterion("fPL =", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplNotEqualTo(int value) {
            addCriterion("fPL <>", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplGreaterThan(int value) {
            addCriterion("fPL >", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplGreaterThanOrEqualTo(int value) {
            addCriterion("fPL >=", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplLessThan(int value) {
            addCriterion("fPL <", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplLessThanOrEqualTo(int value) {
            addCriterion("fPL <=", value, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplBetween(int value1, int value2) {
            addCriterion("fPL between", value1, value2, "fpl");
            return (Criteria) this;
        }

        public Criteria andFplNotBetween(int value1, int value2) {
            addCriterion("fPL not between", value1, value2, "fpl");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}